In SAS OLAP cubes that support multiple languages, dimension table names cannot exceed 32 characters. The 32-character limitation includes the libref, ‘.’ separator, table name, and any non-default locale as specified in the USER_DEFINED_TRANSLATIONS statement.

In the following example, the default dimension table name is Mylib.Cars, and the following locales are specified with the USER_DEFINED_TRANSLATIONS statement:

User_Defined_Translations EN_US JA_JP PL_PL ;

In this case, all of the following dimension table names must contain 32 characters or less.

• Mylib.Cars
• Mylib.CarsJA_JP
• Mylib.CarsPL_PL

If the 32-character limit is exceeded, you might see errors that are similar to these.

ERROR: File MYLIBREF.XXXXX does not exist.
ERROR: File MYLIBREF.XXXXX does not exist.
ERROR: Cube "CUBENAME" cannot be created.

To avoid receiving these error messages, ensure that none of your dimension table names exceed 32 characters when the libref, separator, and any specified locales are included.

Operating System and Release Information